package com.estar.platform.caseInfo.entity;

import java.util.Date;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import org.jeecgframework.core.common.entity.IdEntity;
import org.jeecgframework.poi.excel.annotation.Excel;

import com.estar.app.business.mobileLogin.entity.AppUserEntity;


@Entity
@Table(name = "TMBL_SURVEY_INFO", schema = "")
public class TmblSurveyInfoEntity extends IdEntity implements java.io.Serializable {
	@Excel(name="案件流水号")
	public String reportNo;
	@Excel(name="车牌号")
	public String carsNo;
	@Excel(name="案件状态")
	public String caseStatus;
	@Excel(name="公司代码")
	public String empDptCde;
	@Excel(name="业务员工号")
	public String empCde;
	@Excel(name="案件修改标志")
	public String ifModify;
	@Excel(name="事故类型")
	public String accidentType;
	@Excel(name="出险时间")
	public String dangerTime;
	@Excel(name="出险地点")
	public String dangerPlace;
	@Excel(name="所属交警大队")
	public String trafficPolice;
	@Excel(name="所属地市")
	public String city;
	@Excel(name="指引方式")
	public String guideWay;
	@Excel(name="事故经过")
	public String accidentAfter;
	@Excel(name="是否处理")
	public String checkFlag;
	@Excel(name="是否关联案件")
	public String ifCase;
	@Excel(name="备注")
	public String remark;
	@Excel(name="创建时间")
	public Date createTm;
	@Excel(name="更新时间")
	public Date updateTm;
	@Excel(name="工作地点")
	public String workSpace;
	@Excel(name="服务点电话")
	public String workMobile;
	@Excel(name="甲方手机")
	public String driverPhone;
	@Excel(name="修改备注")
	public String updateRemark;
	@Excel(name="案件是否可疑")
	public String ask;
	@Excel(name="案件减损类型")
	public String askType;
	@Excel(name="案件减损备注")
	public String askRrk;
	@Excel(name="案件审查标记")
	public String surveyExamine;//通过为：p;不通过为：f;新增为：n
	@Excel(name="案件审查意见")
	public String surveyExamineInfo;
	@Excel(name="案件审查人员")
	public String surveyExamineUser;
	
	public AppUserEntity appUser;
	
	@Excel(name="乙方车牌")
	public String yiCarNo;
	@Excel(name="乙方联系方式")
	public String yiPhone;
	
	@Excel(name="抽查案件标记符")//n:没抽查；f：抽查不合格；p：抽查合格
	public String spotCheck;
	@Excel(name="抽查人员")
	public String spotCheckUser;
	@Excel(name="抽查时间")
	public Date spotCheckDate;
	@Excel(name="抽查不合格原因")
	public String spotCheckInfo;
	
	@Excel(name="是否有核损车辆")
	public String evalSur;// t;有
	
	public String jiaDriName;
	public String yiDriName;
	
	@Column(name ="JIADRINAME")
	public String getJiaDriName() {
		return jiaDriName;
	}
	public void setJiaDriName(String jiaDriName) {
		this.jiaDriName = jiaDriName;
	}
	@Column(name ="YIDRINAME")
	public String getYiDriName() {
		return yiDriName;
	}
	public void setYiDriName(String yiDriName) {
		this.yiDriName = yiDriName;
	}
	@Column(name ="T_SPOTCHECK")
	public String getSpotCheck() {
		return spotCheck;
	}
	public void setSpotCheck(String spotCheck) {
		this.spotCheck = spotCheck;
	}
	@Column(name ="T_SPOTCHECk_USER")
	public String getSpotCheckUser() {
		return spotCheckUser;
	}
	public void setSpotCheckUser(String spotCheckUser) {
		this.spotCheckUser = spotCheckUser;
	}
	@Column(name ="T_SPOTCHECK_DATE")
	public Date getSpotCheckDate() {
		return spotCheckDate;
	}
	public void setSpotCheckDate(Date spotCheckDate) {
		this.spotCheckDate = spotCheckDate;
	}
	@Column(name ="T_SPOTCHECK_INFO")
	public String getSpotCheckInfo() {
		return spotCheckInfo;
	}
	public void setSpotCheckInfo(String spotCheckInfo) {
		this.spotCheckInfo = spotCheckInfo;
	}
	@Column(name ="T_CARS_NO_YI")
	public String getYiCarNo() {
		return yiCarNo;
	}
	public void setYiCarNo(String yiCarNo) {
		this.yiCarNo = yiCarNo;
	}
	
	@Column(name ="T_PHONE_YI")
	public String getYiPhone() {
		return yiPhone;
	}
	public void setYiPhone(String yiPhone) {
		this.yiPhone = yiPhone;
	}
	
	@Column(name ="T_EXAMINE")
	public String getSurveyExamine() {
		return surveyExamine;
	}
	public void setSurveyExamine(String surveyExamine) {
		this.surveyExamine = surveyExamine;
	}
	@Column(name ="T_EXAMINE_INFO")
	public String getSurveyExamineInfo() {
		return surveyExamineInfo;
	}
	public void setSurveyExamineInfo(String surveyExamineInfo) {
		this.surveyExamineInfo = surveyExamineInfo;
	}
	@ManyToOne(cascade = { CascadeType.ALL })
	@JoinColumn(name="T_EMP_CDE",referencedColumnName = "T_EMP_CDE")
	//name指的是子表的字段，referencedColumnName指的是本表的字段，如果不加referencedColumnName，就会自动关联到APPUSer表上的ID，如果加了，就会关联到你需要的字段
	public AppUserEntity getAppUser() {
		return appUser;
	}
	public void setAppUser(AppUserEntity appUser) {
		this.appUser = appUser;
	}
	
	@Column(name ="T_WORK_MOBILE")
	public String getWorkMobile() {
		return workMobile;
	}
	public void setWorkMobile(String workMobile) {
		this.workMobile = workMobile;
	}
	
	@Column(name ="T_ASK")
	public String getAsk() {
		return ask;
	}
	public void setAsk(String ask) {
		this.ask = ask;
	}
	
	@Column(name ="T_ASK_TYPE")
	public String getAskType() {
		return askType;
	}
	public void setAskType(String askType) {
		this.askType = askType;
	}
	
	@Column(name ="T_ASK_REMARK")
	public String getAskRrk() {
		return askRrk;
	}
	public void setAskRrk(String askRrk) {
		this.askRrk = askRrk;
	}
	
	@Column(name ="t_driver_phone")
	public String getDriverPhone() {
		return driverPhone;
	}
	public void setDriverPhone(String driverPhone) {
		this.driverPhone = driverPhone;
	}
	
	@Column(name ="t_update_remark")
	public String getUpdateRemark() {
		return updateRemark;
	}
	public void setUpdateRemark(String updateRemark) {
		this.updateRemark = updateRemark;
	}
	
	@Column(name ="T_CHECK_FLAG")
	public String getCheckFlag() {
		return checkFlag;
	}
	public void setCheckFlag(String checkFlag) {
		this.checkFlag = checkFlag;
	}
	
	@Column(name ="T_CARS_NO")
	public String getCarsNo() {
		return carsNo;
	}
	public void setCarsNo(String carsNo) {
		this.carsNo = carsNo;
	}
	
	@Column(name ="t_report_no")
	public String getReportNo() {
		return reportNo;
	}
	public void setReportNo(String reportNo) {
		this.reportNo = reportNo;
	}
	@Column(name ="t_accident_type")
	public String getAccidentType() {
		return accidentType;
	}
	public void setAccidentType(String accidentType) {
		this.accidentType = accidentType;
	}
	
	@Column(name = "T_WORK_SPACE")
	public String getWorkSpace() {
		return workSpace;
	}
	public void setWorkSpace(String workSpace) {
		this.workSpace = workSpace;
	}
	
	@Column(name ="T_DPT_CODE")
	public String getEmpDptCde() {
		return empDptCde;
	}
	public void setEmpDptCde(String empDptCde) {
		this.empDptCde = empDptCde;
	}
	@Column(name ="t_danger_time")
	public String getDangerTime() {
		return dangerTime;
	}
	public void setDangerTime(String dangerTime) {
		this.dangerTime = dangerTime;
	}
	@Column(name ="t_danger_place")
	public String getDangerPlace() {
		return dangerPlace;
	}
	public void setDangerPlace(String dangerPlace) {
		this.dangerPlace = dangerPlace;
	}
	@Column(name ="t_traffic_police")
	public String getTrafficPolice() {
		return trafficPolice;
	}
	public void setTrafficPolice(String trafficPolice) {
		this.trafficPolice = trafficPolice;
	}
	@Column(name ="t_city")
	public String getCity() {
		return city;
	}
	public void setCity(String city) {
		this.city = city;
	}
	@Column(name ="t_guide_way")
	public String getGuideWay() {
		return guideWay;
	}
	public void setGuideWay(String guideWay) {
		this.guideWay = guideWay;
	}
	@Column(name ="t_accident_after")
	public String getAccidentAfter() {
		return accidentAfter;
	}
	public void setAccidentAfter(String accidentAfter) {
		this.accidentAfter = accidentAfter;
	}
	@Column(name ="t_if_case")
	public String getIfCase() {
		return ifCase;
	}
	public void setIfCase(String ifCase) {
		this.ifCase = ifCase;
	}
	@Column(name ="t_remark")
	public String getRemark() {
		return remark;
	}
	public void setRemark(String remark) {
		this.remark = remark;
	}
	@Column(name ="t_create_tm")
	public Date getCreateTm() {
		return createTm;
	}
	public void setCreateTm(Date createTm) {
		this.createTm = createTm;
	}
	@Column(name ="t_case_state")
	public String getCaseStatus() {
		return caseStatus;
	}
	public void setCaseStatus(String caseStatus) {
		this.caseStatus = caseStatus;
	}
	@Column(name ="t_case_modify_state")
	public String getIfModify() {
		return ifModify;
	}
	public void setIfModify(String ifModify) {
		this.ifModify = ifModify;
	}
	@Column(name ="t_update_tm")
	public Date getUpdateTm() {
		return updateTm;
	}
	public void setUpdateTm(Date updateTm) {
		this.updateTm = updateTm;
	}
	@Column(name ="T_EXAMINE_USER")
	public String getSurveyExamineUser() {
		return surveyExamineUser;
	}
	public void setSurveyExamineUser(String surveyExamineUser) {
		this.surveyExamineUser = surveyExamineUser;
	}
	
	@Column(name ="T_EVAR_SUR")
	public String getEvalSur() {
		return evalSur;
	}
	public void setEvalSur(String evalSur) {
		this.evalSur = evalSur;
	}
	
	
}
